USE [NLKHCNData]
GO

/****** Object:  View [dbo].[ChuyenGiaView]    Script Date: 12/26/2014 12:21:27 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[ChuyenGiaView]
AS
SELECT        CG.Id, CG.Ten, CG.HoTen, CG.DiaChiDonVi, HH.Ten AS TenHocHam, HV.Ten AS TenHocVi, CG.TenDonVi, CG.HocHamId, CG.HocViId, LV.Ten AS TenLinhVuc, 
                         CG.LinhVucId
FROM            dbo.ChuyenGia AS CG LEFT OUTER JOIN
                         dbo.LinhVuc AS LV ON CG.LinhVucId = LV.Id LEFT OUTER JOIN
                         dbo.HocHam AS HH ON CG.HocHamId = HH.Id LEFT OUTER JOIN
                         dbo.HocVi AS HV ON CG.HocViId = HV.Id

GO


